26. Conclusion

What we learned:

• What makes a database a relational database and Codd’s 12 rules of relational database design
• The difference between different types of workloads for databases OLAP and OLTP
• The process of database normalization and the normal forms.
• Denormalization and when it should be used.
• Fact vs dimension tables as a concept and how to apply that to our data modeling
• How the star and snowflake schemas use the concepts of fact and dimension tables to make getting value out of the data easier.